﻿CREATE TABLE [Event].[Locations]
(
	LocationID INT NOT NULL IDENTITY(1,1), 
	Title NVARCHAR(255) NOT NULL,
	Address1 NVARCHAR(255),
	Address2 NVARCHAR(255),
	City NVARCHAR(50),
	State NVARCHAR(50),
	PostalCode NVARCHAR(10),
	Directions NVARCHAR(2000),
	Coordinates GEOGRAPHY,
	Coordinates2 AS Coordinates.STAsText()
)
